MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip